﻿CREATE TABLE [dbo].[DimMessageLog]
(
[RecordID] [bigint] NULL,
[ActivityID] [nvarchar] (128) NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL,
[CurrentStep] [nvarchar] (100) NULL,
[CurrentStepDetails] [nvarchar] (500) NULL,
[NextStep] [nvarchar] (100) NULL,
[MessageLog_ID_Key] [int] NOT NULL IDENTITY(1, 1),
[Receive_LocalTime] AS (dateadd(hour, -datediff(hour,getdate(),getutcdate()),[Receive_UTC])),
[Receive_UTC] [datetime] NULL,
[Delta_SinceStart_MS] [int] NULL,
[Delta_SinceLastStep_MS] [int] NULL,
[PreviousRecordID] [nvarchar] (128) NULL,
[ParentRecordID] [nvarchar] (128) NULL,
[InsertDate] [datetime] NULL
) ON [PRIMARY]


